From 57b64522b5f3698660ab99d5d43cb4ae04f523e9 Mon Sep 17 00:00:00 2001 From: Aryeh Gregor Date: Fri, 7 Sep 2007 02:19:08 +0000 Subject: [PATCH] svn add might in some cases be helpful when committing files that did not previously exist. --- maintenance/archives/patch-rev_bot.sql | 5 +++++ maintenance/archives/patch-revision-user-page-index.sql | 5 +++++ 2 files changed, 10 insertions(+) create mode 100644 maintenance/archives/patch-rev_bot.sql create mode 100644 maintenance/archives/patch-revision-user-page-index.sql diff --git a/maintenance/archives/patch-rev_bot.sql b/maintenance/archives/patch-rev_bot.sql new file mode 100644 index 0000000000..12bb5dbc78 --- /dev/null +++ b/maintenance/archives/patch-rev_bot.sql @@ -0,0 +1,5 @@ +-- Add rev_bot column. We don't need an index if all we want to be able to do +-- is, e.g., hide bot edits: most edits are non-bot, so for normal use it's +-- better to just look at 20% more rows or whatever than to add a new index. +ALTER TABLE /*$wgDBprefix*/revision + ADD COLUMN rev_bot tinyint unsigned NOT NULL default 0 AFTER rev_deleted; diff --git a/maintenance/archives/patch-revision-user-page-index.sql b/maintenance/archives/patch-revision-user-page-index.sql new file mode 100644 index 0000000000..9058e4e9fc --- /dev/null +++ b/maintenance/archives/patch-revision-user-page-index.sql @@ -0,0 +1,5 @@ +-- New index on revision table to allow searches for all edits by a given user +-- to a given page. Added 2007-08-28 + +ALTER TABLE /*$wgDBprefix*/revision + ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); -- 2.20.1